Quản lý nhân sự công ty bằng c# _ full source code
60.404 lượt xem;
- frmPhanQuyen.cs
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14
15 namespace QuanLyNhanSu
16 {
17 public partial class frmPhanQuyen : RadForm
18 {
19
20
21 //khai báo biến toàn cục
22 clsUser cUser = new clsUser();
23 clsUser_Right cUser_Right = new clsUser_Right();
24 DataSet ds = new DataSet();
25 public frmPhanQuyen()
26 {
27 InitializeComponent();
28 cboNguoiDung.DataSource = cUser.taocombo();
29 cboNguoiDung.DisplayMember = "User.ID";
30 cboNguoiDung.ValueMember = "User.ID";
31 update(cboNguoiDung.SelectedValue.ToString());
32
33 }
34
35 private void frmPhanQuyen_Load(object sender, EventArgs e)
36 {
37
38 }
39
40 public void update(string ma)
41 {
42 string sqlupd = "Update tbl_User_Form set rights=@right where idform=@id and username='"+ma+"'";
43 SqlCommand cmdupd = new SqlCommand(sqlupd, cUser_Right.sc);
44 SqlParameter right = new SqlParameter("@right", SqlDbType.Bit, 1, "rights");
45 SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 4, "idform");
46
47 string sql = "Select U.idform,F.tenform,U.rights from tbl_user_form U inner join " +
48 "tbl_DMform F on U.idform=F.id where U.username='" + ma + "'";
49
50 SqlCommand cmdsl = new SqlCommand(sql, cUser_Right.sc);
51
52 cmdupd.Parameters.AddRange(new SqlParameter[] { right, id });
53 cUser_Right.sda.UpdateCommand = cmdupd;
54 cUser_Right.sda.SelectCommand = cmdsl;
55 cUser_Right.ds.Clear();
56 cUser_Right.sda.Fill(cUser_Right.ds, "User_Right");
57 cUser_Right.sc.Close();
58
59 }
60
61
62
63 private void btnOK_Click(object sender, EventArgs e)
64 {
65 cUser_Right.sc.Open();
66 cUser_Right.sda.Update(cUser_Right.ds, "User_Right");
67 cUser_Right.sc.Close();
68 RadMessageBox.Show("\nThông tin phân quyền đã được lưu !\n", "Thông báo", MessageBoxButtons.OK, RadMessageIcon.Exclamation);
69 }
70
71 private void cboNguoiDung_SelectedIndexChanged(object sender, EventArgs e)
72 {
73 dgvPhanQuyen.DataSource = cUser_Right.laydl(cboNguoiDung.SelectedValue.ToString());
74 dgvPhanQuyen.DataMember = "User_Right";
75 dgvPhanQuyen.Columns[0].IsVisible = false;
76 dgvPhanQuyen.Columns[1].HeaderText = "Đối tượng form";
77 dgvPhanQuyen.Columns[2].HeaderText = "Truy cập";
78
79
80 //DataGridViewImageColumn dgvIC = new DataGridViewImageColumn();
81
82
83 //dgvIC.Image = new Bitmap(Application.StartupPath + "\\Hinh\\hinhform.gif");
84 //dgvIC.Name = "imageform";
85 //dgvIC.HeaderText = "";
86 //if (dgvPhanQuyen.Columns[0].UniqueName != "imageform")
87 // dgvPhanQuyen.Columns.Insert(0, dgvIC);
88 dgvPhanQuyen.Refresh();
89 update(cboNguoiDung.SelectedValue.ToString());
90 }
91 }
92
93
94 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14
15 namespace QuanLyNhanSu
16 {
17 public partial class frmPhanQuyen : RadForm
18 {
19
20
21 //khai báo biến toàn cục
22 clsUser cUser = new clsUser();
23 clsUser_Right cUser_Right = new clsUser_Right();
24 DataSet ds = new DataSet();
25 public frmPhanQuyen()
26 {
27 InitializeComponent();
28 cboNguoiDung.DataSource = cUser.taocombo();
29 cboNguoiDung.DisplayMember = "User.ID";
30 cboNguoiDung.ValueMember = "User.ID";
31 update(cboNguoiDung.SelectedValue.ToString());
32
33 }
34
35 private void frmPhanQuyen_Load(object sender, EventArgs e)
36 {
37
38 }
39
40 public void update(string ma)
41 {
42 string sqlupd = "Update tbl_User_Form set rights=@right where idform=@id and username='"+ma+"'";
43 SqlCommand cmdupd = new SqlCommand(sqlupd, cUser_Right.sc);
44 SqlParameter right = new SqlParameter("@right", SqlDbType.Bit, 1, "rights");
45 SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 4, "idform");
46
47 string sql = "Select U.idform,F.tenform,U.rights from tbl_user_form U inner join " +
48 "tbl_DMform F on U.idform=F.id where U.username='" + ma + "'";
49
50 SqlCommand cmdsl = new SqlCommand(sql, cUser_Right.sc);
51
52 cmdupd.Parameters.AddRange(new SqlParameter[] { right, id });
53 cUser_Right.sda.UpdateCommand = cmdupd;
54 cUser_Right.sda.SelectCommand = cmdsl;
55 cUser_Right.ds.Clear();
56 cUser_Right.sda.Fill(cUser_Right.ds, "User_Right");
57 cUser_Right.sc.Close();
58
59 }
60
61
62
63 private void btnOK_Click(object sender, EventArgs e)
64 {
65 cUser_Right.sc.Open();
66 cUser_Right.sda.Update(cUser_Right.ds, "User_Right");
67 cUser_Right.sc.Close();
68 RadMessageBox.Show("\nThông tin phân quyền đã được lưu !\n", "Thông báo", MessageBoxButtons.OK, RadMessageIcon.Exclamation);
69 }
70
71 private void cboNguoiDung_SelectedIndexChanged(object sender, EventArgs e)
72 {
73 dgvPhanQuyen.DataSource = cUser_Right.laydl(cboNguoiDung.SelectedValue.ToString());
74 dgvPhanQuyen.DataMember = "User_Right";
75 dgvPhanQuyen.Columns[0].IsVisible = false;
76 dgvPhanQuyen.Columns[1].HeaderText = "Đối tượng form";
77 dgvPhanQuyen.Columns[2].HeaderText = "Truy cập";
78
79
80 //DataGridViewImageColumn dgvIC = new DataGridViewImageColumn();
81
82
83 //dgvIC.Image = new Bitmap(Application.StartupPath + "\\Hinh\\hinhform.gif");
84 //dgvIC.Name = "imageform";
85 //dgvIC.HeaderText = "";
86 //if (dgvPhanQuyen.Columns[0].UniqueName != "imageform")
87 // dgvPhanQuyen.Columns.Insert(0, dgvIC);
88 dgvPhanQuyen.Refresh();
89 update(cboNguoiDung.SelectedValue.ToString());
90 }
91 }
92
93
94 }